﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="FormEditArsip.aspx.vb" Inherits="bisaska.Form_Entry_Edit_Data_Arsip" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<body>
<form id="form1" runat="server" >
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
                    AutoGenerateColumns="False" CellPadding="4" 
                    DataSourceID="Data_Source_Form_SKA_Arsip" GridLines="None" PageSize="5" 
                    DataKeyNames="id_arsip" ForeColor="#333333" >
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                    <Columns>
                        <asp:BoundField DataField="kode_klasifikasi" HeaderText="klasifikasi" 
                            SortExpression="kode_klasifikasi" />
                        <asp:BoundField DataField="kode_divisi" HeaderText="Divisi" 
                            SortExpression="kode_divisi" />
                        <asp:BoundField DataField="perihal" HeaderText="perihal" 
                            SortExpression="perihal" />
                        <asp:BoundField DataField="keyword" HeaderText="keyword" 
                            SortExpression="keyword" />
                        <asp:BoundField DataField="tahun" HeaderText="tahun" SortExpression="tahun" />
                        <asp:BoundField DataField="jangka_retensi" HeaderText="jr" 
                            SortExpression="jangka_retensi" />
                        <asp:BoundField DataField="jumlah_dok" HeaderText="jml_dok" 
                            SortExpression="jumlah_dok" />
                        <asp:BoundField DataField="kode_kontainer" HeaderText="kontainer" 
                            SortExpression="kode_kontainer" />
                        <asp:BoundField DataField="kode_lokasi" HeaderText="lokasi" 
                            SortExpression="kode_lokasi" />
                        <asp:BoundField DataField="status" HeaderText="status" 
                            SortExpression="status" />
                        <asp:BoundField DataField="jenis_arsip" HeaderText="jenis_arsip" 
                            SortExpression="jenis_arsip" />
                        <asp:BoundField DataField="tgl_entry" HeaderText="tgl_entry" 
                            SortExpression="tgl_entry" />
                        <asp:BoundField DataField="user_name" HeaderText="user_name" 
                            SortExpression="user_name" />
                        <asp:BoundField DataField="tgl_validasi" HeaderText="tgl_validasi" 
                            SortExpression="tgl_validasi" />
                        <asp:BoundField DataField="id_validator" HeaderText="id_validator" 
                            SortExpression="id_validator" />
                        <asp:CommandField SelectText="Edit" ShowSelectButton="True" />
                        <asp:TemplateField HeaderText="ACTION">
                        <ItemTemplate>
                        <asp:LinkButton ID="deleteButton" runat="server" CommandName="Delete" Text="Delete"
OnClientClick="return confirm('Yakin Mau Hapus Data Ini?');" />
                        </ItemTemplate>
                                <ControlStyle ForeColor="Black" />
                                <HeaderStyle BorderStyle="None" />
                        </asp:TemplateField>
                        <asp:ButtonField CommandName="btnCopy" Text="Copy" />
                        <asp:BoundField DataField="id_arsip" HeaderText="id_arsip" ReadOnly="True" 
                            SortExpression="id_arsip" />
                    </Columns>
                    <EditRowStyle BackColor="#999999" />
                    <FooterStyle BackColor="#5D7B9D" ForeColor="White" Font-Bold="True" />
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                    <SortedAscendingCellStyle BackColor="#E9E7E2" />
                    <SortedAscendingHeaderStyle BackColor="#506C8C" />
                    <SortedDescendingCellStyle BackColor="#FFFDF8" />
                    <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                </asp:GridView>
                <asp:Button ID="Button3" runat="server" Text="Add New" CssClass="addnew" />
&nbsp;<asp:SqlDataSource ID="Data_Source_Form_SKA_Arsip" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bisaska %>" SelectCommand="select a.id_arsip, b.kode_klasifikasi,c.kode_divisi,a.perihal,keyword,tahun,jangka_retensi,jumlah_dok,
d.kode_kontainer,e.kode_lokasi,f.status,g.jenis_arsip,a.tgl_entry,
h.user_name,a.tgl_validasi,id_validator
from 
T_SKA_ARSIP a join T_MST_KLASIFIKASI b on a.id_klasifikasi = b.id_klasifikasi join T_MST_DIVISI c on a.id_divisi = c.id_divisi join T_MST_KONTAINER d on a.id_kontainer = d.id_kontainer join T_MST_LOKASI e on a.id_lokasi = e.id_lokasi join T_MST_STATUS f on a.id_status = f.id_status join T_MST_JENIS_ARSIP g on a.id_jenis_arsip = g.id_jenis_arsip join T_MST_USER h on a.id_pengentry = h.id_user 
"
DeleteCommand="DELETE FROM [T_SKA_ARSIP] WHERE [id_arsip] = @id_arsip"
>
                    <DeleteParameters>
                        <asp:Parameter Name="id_arsip" Type="Int64" />
                    </DeleteParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="Kode_Klasifikasi" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bisaska %>" 
                    
        SelectCommand="SELECT [kode_klasifikasi] FROM [T_MST_KLASIFIKASI]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="Kode_Divisi" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bisaska %>" 
                    SelectCommand="SELECT [kode_divisi] FROM [T_MST_DIVISI]"></asp:SqlDataSource>
                <asp:SqlDataSource ID="Kontainer" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bisaska %>" 
                    
        SelectCommand="SELECT [kode_kontainer] FROM [T_MST_KONTAINER]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="Lokasi" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bisaska %>" 
                    SelectCommand="SELECT [kode_lokasi] FROM [T_MST_LOKASI]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="Jenis_Arsip" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bisaska %>" 
                    
    SelectCommand="SELECT [jenis_arsip] FROM [T_MST_JENIS_ARSIP]">
                </asp:SqlDataSource>
            </div>

            <div class="editbox">
            <table ID= "tabel1" runat = "server">
            <tr>
                    <td><span class="font">Kode Klasifikasi:</span></td>
                    <td><asp:DropDownList ID="dropdownlist1" runat="server" 
                            DataSourceID="Kode_Klasifikasi" DataTextField="kode_klasifikasi" 
                            DataValueField="kode_klasifikasi">
                        <asp:ListItem></asp:ListItem>
                        </asp:DropDownList></td>
                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    <td><span class="font">Tahun:&nbsp;&nbsp;&nbsp;&nbsp;</span></td>
                    <td><asp:TextBox ID="textbox1" runat="server" CssClass="textbox"></asp:TextBox></td>
            </tr>
            <tr>
                    <td><span class="font">Divisi Pemilik:</span></td>
                    <td><asp:DropDownList ID="dropdownlist2" runat="server" 
                            DataSourceID="Kode_Divisi" DataTextField="kode_divisi" 
                            DataValueField="kode_divisi"></asp:DropDownList></td>
                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    <td><span class="font">Jangka Retensi:&nbsp;&nbsp;&nbsp;&nbsp;</span></td>
                    <td><asp:TextBox ID="textbox2" runat="server" CssClass="textbox"></asp:TextBox></td>
            </tr>
            <tr>
                    <td valign="top"><span class="font">Perihal:</span></td>
                    <td valign="top"><asp:Textbox ID="textbox3" runat="server" CssClass="textbox" 
                            Height="70px" MaxLength="150" TextMode="MultiLine"></asp:Textbox></td>
                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    <td colspan="2"><span class="font">Jumlah Dokumen:</span>
                    <asp:TextBox ID="textbox4" runat="server" CssClass="textbox"></asp:TextBox> <br />
                    <span class="font">Kontainer:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>
                    <asp:DropDownList ID="dropdownlist3" runat="server" 
                            DataSourceID="Kontainer" DataTextField="kode_kontainer" 
                            DataValueField="kode_kontainer"></asp:DropDownList></td>

            </tr>
            <tr>
                    <td valign="top"><span class="font">Keyword:</span></td>
                    <td valign="top"><asp:TextBox ID="textbox5" runat="server" CssClass="textbox" Height="70px" MaxLength="150" TextMode="MultiLine"></asp:TextBox></td>
                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    <td colspan="2"><span class="font">Lokasi:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>
                    <asp:DropDownList ID="dropdownlist4" runat="server" 
                            DataSourceID="Lokasi" DataTextField="kode_lokasi" 
                            DataValueField="kode_lokasi"></asp:DropDownList> <br />
                    <span class="font">Jenis Arsip:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>
                    <asp:DropDownList ID="dropdownlist5" runat="server" 
                            DataSourceID="Jenis_Arsip" DataTextField="jenis_arsip" 
                            DataValueField="jenis_arsip"></asp:DropDownList></td>

            </tr>
            <tr>
                    <td colspan="3">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                         <asp:Button ID="button1" runat="server" Text="Save" CssClass="tombol"></asp:Button>
                         <asp:Button ID="button2" runat="server" Text="Cancel" CssClass="tombol"></asp:Button></td>

                </tr>
            </table>
            </div>
            </div>
    </form>
</body>
</asp:Content>
